The SQL API integration code "FMISSQLAPI" is used integration LinkSOFT with a FMIS database.

The following SQL API integration packs are available:

1. EPICOR 7.2
2. JIWA 6  
3. JIWA 7
4. Microsoft AX
5. Vodafone Webstore
6. Numerical Computer System Suite

Steps to configure the SQL API integration :

1. Apply the appropriate SQL API integration scripts using SSMS to the FMIS/ERP database. The scripts are located in the installed folder: <Installed Folder>\Link Technologies\DBIntegrationScripts
2. Configure the connection details in menu "Integration -> Integration Setup -> FMISSQLAPI -> Integration Settings"
   1. Server Name: Enter the SQL Server instance name. Leave this blank if the FMIS database is on the same server as LinkSOFT. Users need to configure "Distributed Transactions Coordinator (DTC)"
   2. Database Name : Enter the FMIS database name
   3. User Name : Enter the SQL User Login Name that will be used to connect to the FMIS database. This field is required when the FMIS database is on a different server.
   4. Password : Enter the SQL User's password.
3. Enable the following processes in menu "Company Administration -> Processes". These processes are used to interact between LinkSOFT and FMIS database.
   1. FMIS Import - Perform all master file import from FMIS. This includes Accounts Receivable, Accounts Payable, Inventory and General Ledger
   2. FMIS AP - Perform FMIS integration for Accounts Payable
   3. FMIS AR - Perform FMIS integration for Accounts Receivable Process
   4. FMIS AR Validate - Perform FMIS integration for Accounts Receivable Validate
   5. FMIS GL - Perform FMIS integration for General Ledger